/*
 * All content copyright http://www.j2eefast.com, unless
 * otherwise indicated. All rights reserved.
 * No deletion without permission
 */
package com.j2eefast.flowable.bpm.entity;


import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonProperty;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * <p>认领信息</p>
 *
 * @author: zhangyuan
 * @date: 2021-04-29 22:18
 * @web: http://www.letukeji.cn
 * @version: 1.0.1
 */
@Data
@TableName("project_sanlian")
//设置头高
@HeadRowHeight(20)
@ColumnWidth(15)		// 表头行宽
@HeadFontStyle(fontHeightInPoints = 12)
@ExcelIgnoreUnannotated
public class ProjectSanLianEntity {
	@TableId(value = "id")

	protected Long id;
	//到账金额
	@ExcelProperty("到账金额")
	@TableField(value = "contract_no")
	protected BigDecimal contractNo;
	//合同编号
	@ExcelProperty("合同编号")
	@TableField(value = "billing")
	protected BigDecimal billing;
	//开票金额回写
	@ExcelProperty("开票金额回写")
	@TableField(value = "contract_no")
	protected BigDecimal contract_no;
	//已结算到账金额
	@ExcelProperty("已结算到账金额")
	@TableField(value = "settlement")
	protected BigDecimal settlement;
	//税金
	@ExcelProperty("税金")
	@TableField(value = "taxes")
	protected BigDecimal taxes;
	//管理费
	@ExcelProperty("管理费")
	@TableField(value = "manage")
	protected BigDecimal manage;
	//仪器费
	@ExcelProperty("仪器费")
	@TableField(value = "instrument")
	protected BigDecimal instrument;
	//材料费
	@ExcelProperty("材料费")
	@TableField(value = "material")
	protected BigDecimal material;
	//报告审查费
	@ExcelProperty("报告审查费")
	@TableField(value = "reports")
	protected BigDecimal reports;
	//管理费合计
	@ExcelProperty("管理费合计")
	@TableField(value = "manage_total")
	protected BigDecimal manageTotal;
	//管税总计
	@ExcelProperty("管税总计")
	@TableField(value = "tax")
	protected BigDecimal tax;
	//劳务费
	@ExcelProperty("劳务费")
	@TableField(value = "fee")
	protected BigDecimal fee;
	//总计
	@ExcelProperty("总计")
	@TableField(value = "total")
	protected BigDecimal total;
	//可结算资金
	@ExcelProperty("可结算资金")
	@TableField(value = "settlements")
	protected BigDecimal settlements;
	//贴票金额
	@ExcelProperty("贴票金额")
	@TableField(value = "ticket")
	protected BigDecimal ticket;
	//其他费用
	@ExcelProperty("其他费用")
	@TableField(value = "other")
	protected BigDecimal other;
	//备注
	@ExcelProperty("备注")
	@TableField(value = "remarks")
	protected String remarks;
	//状态
	@ExcelProperty("状态")
	@TableField(value = "status")
	protected String status;

	@ExcelProperty("创建时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss" , timezone = "GMT+8")
	@TableField(value = "create_time")

	protected Date createTime;
	@ExcelProperty("最近更新时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss" , timezone = "GMT+8")
	@TableField(value = "update_time")
	protected Date updateTime;
	//应贴票金额
	@ExcelProperty("应贴票金额")
	@TableField(value = "should")
	protected BigDecimal should;
	//合同额
	@ExcelProperty("合同额")
	@TableField(value = "contract_sum")
	protected BigDecimal contractSum;
	//三联单号
	@ExcelProperty("三联单号")
	@TableField(value = "sanlian_no")
	protected String sanlianNo;
	//项目档案编号
	@ExcelProperty("项目档案编号")
	@TableField(value = "file_number")
	protected String fileNumber;
	//项目经理

	@ExcelProperty("项目经理")
	@TableField(value = "ceo_name")
	protected String ceoName;
	//开具部门
	@ExcelProperty("开具部门")
	@TableField(value = "open_department")
	protected String openDepartment;
	//项目名称
	@ExcelProperty("项目名称")
	@TableField(value = "project_name")
	protected String projectName;
	//付款单位
	@ExcelProperty("付款单位")
	@TableField(value = "payment_nuit")
	protected String paymentNuit;

	//三联编号
	@ExcelProperty("三联编号")
	@TableField(value = "name")
	protected String name;
	//项目经理id
	@ExcelProperty("到账金额")
	@TableField(value = "name_id")
	protected Long nameId;
	//用户id
	@ExcelProperty("到账金额")
	@TableField(value = "user_id")
	protected Long userId;
	//项目档案id
	@ExcelProperty("到账金额")
	@TableField(value = "file_id")
	protected Long fileId;

//	@TableLogic
//	@JsonProperty(access = JsonProperty.Access.WRITE_ONLY)
//	@TableField(value = "del_flag", fill = FieldFill.INSERT)
//	private String delFlag;





}
